from sqlalchemy import Column, Integer, String, DateTime
from module_admin.entity.do.base import db


class Assignment(db.Model):
    __tablename__ = 'sys_assignments'
    # 表注释
    __table_args__ = {'comment': '作业表'}

    id = Column(Integer, primary_key=True, autoincrement=True)
    title = Column(String(100), nullable=False)
    description = Column(String(500), nullable=True)
    course_id = Column(Integer, comment='课程ID')
    created_by = Column(String(64, collation='utf8_general_ci'), default='', comment='创建者')
